Skip to main content

Datasource Amazon DynamoDB

Amazon DynamoDB is RDBMS (relational database management system), In OPNBI we are connecting Datasource with Amazon DynamoDB JDBC drivers.

To add the Amazon DynamoDB Datasource JDBC driver with OPNBI, follow the steps below:​

  • To get the JDBC driver, Go the vendor's end and download the (Amazon DynamoDB-connector-java.jar) Driver file.

  • Take the Amazon DynamoDB -connector-java from vendor

  • After downloading the jar file, add it into the OPNBI.

  • To add Go to the library folder OPNBI\apache-tomcat-8.5.61\webapps\OPNBI\WEB-INF\lib folder and add the .jar file here.

Connecting Amazon DynamoDB Datasource with OPNBI

Go to the Master data section and click on Data Source, as shown in the figure below:

Docusaurus Slash Introduction

Click on Create button from the bottom horizontal menu bar from Datasource section, as shown in the figure below:

Docusaurus Slash Introduction

The Create Datasource window will open, as shown in the figure below:

Docusaurus Slash Introduction

Search for Amazon DynamoDB data source from Top-right search bar in Datasource section, as shown in the figure below:

Docusaurus Slash Introduction

Click on Amazon DynamoDB to create a data source using Amazon DynamoDB.

Docusaurus Slash Introduction

As you click on Amazon DynamoDB, the create dialog box will pop-up on screen, as shown in the figure below:

Docusaurus Slash Introduction

Insert the following data in the Datasource connection Dialog box:

Enter Display Name: Amazon DynamoDB [ Add name as per your requirements]

Enter Class: com.simba.dynamodb.jdbc.Driver

Enter Connection URL: jdbc:dynamodb:jdbc:amazondynamodb:Access Key=<'Accesskey'>;Secret Key=<'Secret Key'>;Domain=amazonaws.com;Region=OREGON; [Add Connection URL as per your Datasource connection]

Enter Username: [Provide the username of your Amazon DynamoDB Datasource]

Enter Password: [Enter your respective Amazon DynamoDB password]

Click on Test Connection Button to Check Database Connection, after Connection Successful.

Click on ok and save button to close the Dialog box.

Docusaurus Slash Introduction

Select the Amazon DynamoDB DataSource and click on Create Dataset, as shown in figure below:

Docusaurus Slash Introduction

When you click on create Dataset the following screen will be display.

Docusaurus Slash Introduction

Enter the Following details in Dataset.

Name: Amazon DynamoDB (Add name as per your requirements)

Source: Amazon DynamoDB (select the data source which you have created)

DataSource: JDBC